<?php 
	error_reporting(E_ALL);
	require_once("./include/db_info.inc.php");
	echo "http://chamthi.net/\n";
	echo "http://chamthi.net/exercises.php\n";
	$sql="select contest_id from contest where author_id='admin' and `defunct`='N' and `private`=0";
	$ret = mysql_query($sql);
	while ($row=mysql_fetch_array($ret)) {
		echo "http://chamthi.net/exercises.php?cid=".$row['contest_id']."\n";
	}
	
	$sql="select problem_id from problem where  `defunct`='N' ";
	$ret = mysql_query($sql);
	while ($row=mysql_fetch_array($ret)) {
		echo "http://chamthi.net/exercise.php?id=".$row['problem_id']."\n";
	}
	
	$sql="select `guid` from bv_posts where  `post_type`='post' ";
	$ret = mysql_query($sql);
	while ($row=mysql_fetch_array($ret)) {
		echo $row['guid']."\n";
	}
	
	$sql="select `forum_id` from dd_forums  ";
	$ret = mysql_query($sql);
	while ($row=mysql_fetch_array($ret)) {
		echo "http://chamthi.net/viewforum.php?f=".$row['forum_id']."\n";
	}
	$sql="select DISTINCT topic_id,forum_id from dd_posts  ";
	$ret = mysql_query($sql);
	while ($row=mysql_fetch_array($ret)) {
		echo "http://chamthi.net/viewtopic.php?f=".$row['forum_id']."&t=".$row['topic_id']."\n";
	}
	
?>
